Data Source

This property box determines which data source the Custom Query, Insert Data, Query Data, and Update Data activities will use.

To select a data source

  1. Add a Custom Query, Insert Data, Query Data, or Update Data activity to your workflow definition by dragging it from the Toolbox Pane and dropping it in the Designer Pane.
  2. Select the activity in the Designer Pane.
  3. Under ClosedData Source in the Properties Pane, select a data source from the drop-down menu.
  4. Note: Because the Workflow Server performs the data-source queries, you must create all data sources on the Workflow Server. Services cannot access mapped drives when you are setting up the data source.

  5. Optional: To add, configure, remove, or test a connection to an external data source, select Manage Data Sources from the drop-down menu. More information.
  6. Optional: Click the refresh icon to update the list of data sources available in the drop-down menu.